package com.edu.dao;

import java.util.List;

import com.edu.bean.Orders;
import com.edu.bean.Ordersdata;

public interface OrdersDao {
	/**
	 * 根据分页查询所有订单
	 * @return
	 */
	List<Orders> selectAll(int pageNum,int pageSize);
	/**
	 * 查询订单总数
	 * @return
	 */
	int selectAllorder(Orders order);
	/**
	 * 根据id来删除订单
	 * @param orderid
	 * @return
	 */
	int deleteOrderById(int orderid);
	/**
	 * 全字段修改
	 * @param order
	 * @return
	 */
	int updateOrders(Orders order);
	/**
	 * 根据Id来查询订单
	 * @param orderid
	 * @return
	 */
	Orders selectOrdersById(int orderid);
	/**
	 * 查询已付款的总金额
	 * @return
	 */
	int selectpriceAll();
	/**
	 * 各月份的金额查询
	 * @return
	 */
	int sleectonetotal();
	int sleecttwototal();
	int sleectthreetotal();
	int sleectfourtotal();
	int sleectfivetotal();
	int sleectsixtotal();
	int sleectseventotal();
	int sleecteighttotal();
	int sleectninetotal();
	int sleecttentotal();
	int sleecteleventotal();
	int sleecttwelvetotal();
}
